Purpose |
Including Contract Information in EPM210 - Customer Segment Scorecard |
Release No |
018 |
Submitted |
04-05-2013 |
Submitted by |
Mallareddy D |
Source/Destination Systems |
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment |
Release Sent To |
Mark Harris |
Object(s) Created By |
Narendra Koraganji |
Object(s) Tested By |
Narendra Koraganji |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped YTD |
65,895,548 |
65,895,548 |
Pass |
2 |
Last Year Shipped YTD |
49,535,432 |
49,535,432 |
Pass |
3 |
Current Year Budget YTD |
81,480,846 |
81,480,846 |
Pass |
4 |
Total Open Revenue |
128,132,426 |
128,132,426 |
Pass |
5 |
Total Shipped Current Year |
194,027,973 |
194,027,973 |
Pass |
6 |
Total Shipped Last Year |
447,596,834 |
447,596,834 |
Pass |
7 |
Total Budget Current Year |
516,707,703 |
516,707,703 |
Pass |
8 |
TY Quantity |
5,913,844 |
5,913,844 |
Pass |
9 |
LY Quantity |
4,735,464 |
4,735,464 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped YTD |
58,189,876 |
58,189,876 |
Pass |
2 |
Open |
110,926,270 |
110,926,270 |
Pass |
3 |
Total Revenue YTD |
169,116,146 |
169,116,146 |
Pass |
4 |
Last Year Shipped YTD |
49,414,043 |
49,414,043 |
Pass |
5 |
Current Year Budget YTD |
71,549,289 |
71,549,289 |
Pass |
6 |
TY Quantity |
5,072,270 |
5,072,270 |
Pass |
7 |
LY Quantity |
4,726,020 |
4,726,020 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
36,077,617 |
36,077,617 |
Pass |
2 |
Open |
40,517,831 |
40,517,831 |
Pass |
3 |
Total |
76,595,447 |
76,595,447 |
Pass |
4 |
Last Year |
30,673,492 |
30,673,492 |
Pass |
5 |
Budget |
41,006,366 |
41,006,366 |
Pass |
6 |
TY Quantity |
3,041,465 |
3,041,465 |
Pass |
7 |
LY Quantity |
2,539,906 |
2,539,906 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
15,119,373 |
15,119,373 |
Pass |
2 |
Open |
27,515,165 |
27,515,165 |
Pass |
3 |
Total |
42,634,538 |
42,634,538 |
Pass |
4 |
Last Year |
11,489,793 |
11,489,793 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
1,202,231 |
1,202,231 |
Pass |
7 |
LY Quantity |
931,121 |
931,121 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
31,047,681 |
31,047,681 |
Pass |
2 |
Open |
39,696,017 |
39,696,017 |
Pass |
3 |
Total |
70,743,699 |
70,743,699 |
Pass |
4 |
Last Year |
28,811,657 |
28,811,657 |
Pass |
5 |
Budget |
38,980,491 |
38,980,491 |
Pass |
6 |
TY Quantity |
2,106,764 |
2,106,764 |
Pass |
7 |
LY Quantity |
2,304,102 |
2,304,102 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
14,315,104 |
14,315,104 |
Pass |
2 |
Open |
38,401,326 |
38,401,326 |
Pass |
3 |
Total |
52,716,430 |
52,716,430 |
Pass |
4 |
Last Year |
10,890,258 |
10,890,258 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
1,880,401 |
1,880,401 |
Pass |
7 |
LY Quantity |
1,490,916 |
1,490,916 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped MTD |
42,158,008 |
42,158,008 |
Pass |
2 |
Last Year Shipped MTD |
34,323,003 |
34,323,003 |
Pass |
3 |
Budget Current Year MTD |
0 |
0 |
Pass |
4 |
TY Quantity Current Year MTD |
3,649,036 |
3,649,036 |
Pass |
5 |
LY Quantity Last Year MTD |
3,201,655 |
3,201,655 |
Pass |
6 |
Budget Quantity Current Year MTD |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped YTD |
152,138 |
152,137.70 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total Revenue YTD |
152,138 |
152,137.70 |
Pass |
4 |
Last Year Shipped YTD |
47,616 |
47,615.94 |
Pass |
5 |
Current Year Budget YTD |
64,700 |
64,700 |
Pass |
6 |
TY Quantity |
12,579 |
12,579 |
Pass |
7 |
LY Quantity |
4,691 |
4,691 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
4,819,412 |
4,819,412 |
Pass |
2 |
Open |
170,574 |
170,574 |
Pass |
3 |
Total |
4,989,986 |
4,989,986 |
Pass |
4 |
Last Year |
4,152,066 |
4,152,066 |
Pass |
5 |
Budget |
3,102,811 |
3,102,811 |
Pass |
6 |
TY Quantity |
410,101 |
410,101 |
Pass |
7 |
LY Quantity |
362,021 |
362,021 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
1,746,159 |
1,746,159 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total |
1,746,159 |
1,746,159 |
Pass |
4 |
Last Year |
3,015,394 |
3,015,394 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
135,758 |
135,758 |
Pass |
9 |
LY Quantity |
243,398 |
243,398 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
5,589,304 |
5,589,304 |
Pass |
2 |
Open |
1,775 |
1,775 |
Pass |
3 |
Total |
5,591,079 |
5,591,079 |
Pass |
4 |
Last Year |
3,983,225 |
3,983,225 |
Pass |
5 |
Budget |
7,235,165 |
7,235,165 |
Pass |
8 |
TY Quantity |
547,081 |
547,081 |
Pass |
9 |
LY Quantity |
491,967 |
491,967 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
4,364,304 |
4,364,304 |
Pass |
2 |
Open |
13,677 |
13,677 |
Pass |
3 |
Total |
4,377,982 |
4,377,982 |
Pass |
4 |
Last Year |
4,253,290 |
4,253,290 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
337,462 |
337,462 |
Pass |
9 |
LY Quantity |
333,224 |
333,224 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped YTD |
680,870 |
680,870 |
Pass |
2 |
Last Year Shipped YTD |
539,655 |
539,655 |
Pass |
3 |
Current Year Budget YTD |
0 |
0 |
Pass |
4 |
Total Open Revenue |
627,637 |
627,637 |
Pass |
5 |
Total Shipped Current Year |
1,308,508 |
1,308,508 |
Pass |
6 |
Total Shipped Last Year |
3,085,038 |
3,085,038 |
Pass |
7 |
Total Budget Current Year |
0 |
0 |
Pass |
8 |
TY Quantity |
52,743 |
52,743 |
Pass |
9 |
LY Quantity |
40,523 |
40,523 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
678,471 |
678,471 |
Pass |
2 |
Open |
627,556 |
627,556 |
Pass |
3 |
Total |
1,306,027 |
1,306,027 |
Pass |
4 |
Last Year |
538,665 |
538,665 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
52,579 |
52,579 |
Pass |
7 |
LY Quantity |
40,448 |
40,448 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
250,407 |
250,407 |
Pass |
2 |
Open |
75,638 |
75,638 |
Pass |
3 |
Total |
326,045 |
326,045 |
Pass |
4 |
Last Year |
182,960 |
182,960 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
17,858 |
17,858 |
Pass |
7 |
LY Quantity |
12,583 |
12,583 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
50,736 |
50,736 |
Pass |
2 |
Open |
6,980 |
6,980 |
Pass |
3 |
Total |
57,716 |
57,716 |
Pass |
4 |
Last Year |
26,175 |
26,175 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
4,459 |
4,459 |
Pass |
7 |
LY Quantity |
2,042 |
2,042 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
278,712 |
278,712 |
Pass |
2 |
Open |
98,704 |
98,704 |
Pass |
3 |
Total |
377,416 |
377,416 |
Pass |
4 |
Last Year |
225,477 |
225,477 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
21,433 |
21,433 |
Pass |
7 |
LY Quantity |
15,419 |
15,419 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
319,810 |
319,810 |
Pass |
2 |
Open |
67,198 |
67,198 |
Pass |
3 |
Total |
387,009 |
387,009 |
Pass |
4 |
Last Year |
156,596 |
156,596 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
26,238 |
26,238 |
Pass |
7 |
LY Quantity |
12,297 |
12,297 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped MTD |
209,234 |
209,234 |
Pass |
2 |
Last Year Shipped MTD |
327,394 |
327,394 |
Pass |
3 |
Budget Current Year MTD |
48,708,540 |
48,708,540 |
Pass |
4 |
TY Quantity Current Year MTD |
15,479 |
15,479 |
Pass |
5 |
LY Quantity Last Year MTD |
24,873 |
24,873 |
Pass |
6 |
Budget Quantity Current Year MTD |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
207,134 |
207,134 |
Pass |
2 |
Open |
2,916 |
2,916 |
Pass |
3 |
Total |
210.050 |
210.050 |
Pass |
4 |
Last Year |
327,394 |
327,394 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
15,339 |
15,339 |
Pass |
7 |
LY Quantity |
24,873 |
24,873 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
68,631 |
68,631 |
Pass |
2 |
Open |
2,916 |
2,916 |
Pass |
3 |
Total |
71,547 |
71,547 |
Pass |
4 |
Last Year |
99,325 |
99,325 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
4,893 |
4,893 |
Pass |
7 |
LY Quantity |
7,880 |
7,880 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
13,042 |
13,042 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total |
13,042 |
13,042 |
Pass |
4 |
Last Year |
6,003 |
6,003 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
846 |
846 |
Pass |
9 |
LY Quantity |
427 |
427 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
45,911 |
45,911 |
Pass |
2 |
Open |
2,916 |
2,916 |
Pass |
3 |
Total |
48,827 |
48,827 |
Pass |
4 |
Last Year |
187,605 |
187,605 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
3,560 |
3,560 |
Pass |
9 |
LY Quantity |
14,670 |
14,670 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
124,992 |
124,992 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total |
124,992 |
124,992 |
Pass |
4 |
Last Year |
128,269 |
128,269 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
9,325 |
9,325 |
Pass |
9 |
LY Quantity |
9,987 |
9,987 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped YTD |
680,870 |
680,870 |
Pass |
2 |
Last Year Shipped YTD |
536,737 |
536,737 |
Pass |
3 |
Current Year Budget YTD |
0 |
0 |
Pass |
4 |
Total Open Revenue |
627,637 |
627,637 |
Pass |
5 |
Total Shipped Current Year |
1,308,508 |
1,308,508 |
Pass |
6 |
Total Shipped Last Year |
3,082,121 |
3,082,121 |
Pass |
7 |
Total Budget Current Year |
0 |
0 |
Pass |
8 |
TY Quantity |
52,743 |
52,743 |
Pass |
9 |
LY Quantity |
40,337 |
40,337 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
678,471 |
678,471 |
Pass |
2 |
Open |
627,556 |
627,556 |
Pass |
3 |
Total |
1,306,027 |
1,306,027 |
Pass |
4 |
Last Year |
535,748 |
535,748 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
52,579 |
52,579 |
Pass |
7 |
LY Quantity |
40,262 |
40,262 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
250,407 |
250,407 |
Pass |
2 |
Open |
75,638 |
75,638 |
Pass |
3 |
Total |
326,045 |
326,045 |
Pass |
4 |
Last Year |
182,960 |
182,960 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
17,858 |
17,858 |
Pass |
7 |
LY Quantity |
12,583 |
12,583 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
50,736 |
50,736 |
Pass |
2 |
Open |
6,980 |
6,980 |
Pass |
3 |
Total |
57,716 |
57,716 |
Pass |
4 |
Last Year |
26,175 |
26,175 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
4,459 |
4,459 |
Pass |
7 |
LY Quantity |
2,042 |
2,042 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
278,712 |
278,712 |
Pass |
2 |
Open |
98,704 |
98,704 |
Pass |
3 |
Total |
377,416 |
377,416 |
Pass |
4 |
Last Year |
225,477 |
225,477 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
21,433 |
21,433 |
Pass |
7 |
LY Quantity |
15,419 |
15,419 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
319,810 |
319,810 |
Pass |
2 |
Open |
67,198 |
67,198 |
Pass |
3 |
Total |
387,009 |
387,009 |
Pass |
4 |
Last Year |
156,596 |
156,596 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
26,238 |
26,238 |
Pass |
7 |
LY Quantity |
12,297 |
12,297 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Current Year Shipped MTD |
209,234 |
209,234 |
Pass |
2 |
Last Year Shipped MTD |
324,476 |
324,476 |
Pass |
3 |
Budget Current Year MTD |
0 |
0 |
Pass |
4 |
TY Quantity Current Year MTD |
15,479 |
15,479 |
Pass |
5 |
LY Quantity Last Year MTD |
24,687 |
24,687 |
Pass |
6 |
Budget Quantity Current Year MTD |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
207,134 |
207,134 |
Pass |
2 |
Open |
2.916 |
2,916 |
Pass |
3 |
Total |
210,050 |
210,050 |
Pass |
4 |
Last Year |
324.476 |
324.476 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
15,339 |
15,339 |
Pass |
9 |
LY Quantity |
24,687 |
24,687 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
68,631 |
68,631 |
Pass |
2 |
Open |
2,916 |
2,916 |
Pass |
3 |
Total |
71,547 |
71,547 |
Pass |
4 |
Last Year |
99,325 |
99,325 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
6 |
TY Quantity |
4,893 |
4,893 |
Pass |
7 |
LY Quantity |
7,880 |
7,880 |
Pass |
8 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
12,221 |
12,221 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total |
12,221 |
12,221 |
Pass |
4 |
Last Year |
58,132 |
58,132 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
1,212 |
1,212 |
Pass |
9 |
LY Quantity |
4,617 |
4,617 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
45,911 |
45,911 |
Pass |
2 |
Open |
2,916 |
2,916 |
Pass |
3 |
Total |
48,827 |
48,827 |
Pass |
4 |
Last Year |
184,687 |
184,687 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
3,560 |
3,560 |
Pass |
9 |
LY Quantity |
14,484 |
14,484 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |
SNo |
Test Case |
Value in CR |
Value in BEx/Budget Sheet |
Pass/Fail Criteria |
1 |
Shipped |
124,992 |
124,992 |
Pass |
2 |
Open |
0 |
0 |
Pass |
3 |
Total |
124,992 |
124,992 |
Pass |
4 |
Last Year |
128,269 |
128,269 |
Pass |
5 |
Budget |
0 |
0 |
Pass |
8 |
TY Quantity |
9,325 |
9,325 |
Pass |
9 |
LY Quantity |
9,987 |
9,987 |
Pass |
10 |
Budget Quantity |
0 |
0 |
Pass |